﻿CREATE ROLE [RestoreUser] AUTHORIZATION dbo;
GO
GRANT EXECUTE ON [dbo].[spBkp_Differential] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spBkp_Full] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spBkp_Log] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spBkp_SnapshotCreate] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spBkp_SnapshotDrop] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spBkp_SnapshotExists] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spIO_CompressDatabase] TO RestoreUser
GO
GRANT EXECUTE ON [dbo].[spIO_ShrinkFile] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spMaint_InsertLogEntry] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_BackupFile] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_ByBackupSetID] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_ByLabel] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_ByPointInTime] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_ChangeUsersLogin] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_DetermineLastBackup] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_GetAllBackups] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_GetLastLabel] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_GetRestoreScripts] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_IsAllowed] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_KillProcesses] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_ListDatabases] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_RecoverDatabase] TO RestoreUser;
GO
GRANT EXECUTE ON [dbo].[spRest_Snapshot] TO RestoreUser;
GO

GRANT EXECUTE ON [dbo].[fnConfig_IsDatabaseNoArchive] TO RestoreUser;
GO
